package com.web.dao;

import com.web.dto.StoreApplyDto;
import com.web.entity.KftBusinesscategory;
import com.web.entity.Kftprovincialcity;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.type.JdbcType;

/**
 *快付通经营类目DAO层
 * @author Welcome Chen
 * @date 2018-08-21
 */
public interface KftBusinesscategoryMapper {
    @Select( {
            "select",
            " id, industry1, category2, category3,businessNumber ",
            " from t_kftBusinesscategory",
            " where industry1 = #{industry1,jdbcType=VARCHAR} and category2 = #{category2,jdbcType=VARCHAR} and category3 = #{category3,jdbcType=VARCHAR}"
    } )
    @Results({
            @Result(column = "id", property = "id", jdbcType = JdbcType.BIGINT, id = true),
            @Result(column = "industry1", property = "industry1", jdbcType = JdbcType.VARCHAR),
            @Result(column = "category2", property = "category2", jdbcType = JdbcType.VARCHAR),
            @Result(column = "category3", property = "category3", jdbcType = JdbcType.VARCHAR),
            @Result(column = "businessNumber", property = "businessNumber", jdbcType = JdbcType.VARCHAR)
    })
    KftBusinesscategory selectByCategory(StoreApplyDto storeApplyDto);
}
